2015-07-29 - 16697.1300 - Spec - Returns Invoice File #CrystalReportDevelopment
SPECIFICATIONS
16697.1300 - Returns Invoice File
Requirement Summary
Need to create the Returns Invoice File report.
Admin Info
| Purpose |
Need to create the Returns Invoice File report. |
| Requested By |
Thi Tran |
| Spec Created By |
Dhananjay G |
| Spec Created Date |
07/29/2015 |
| Spec QA by |
Uday Kumar P |
| Objects |
Tables VBAK, VBRK, VBRP, LIPS and KONV |
| Document Status |
Complete |
Estimates
| SNo |
Activity |
Estimation in Hours |
| 1 |
Research |
00 |
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
34 |
| 4 |
Unit test in DEV |
00 |
| 5 |
Unit test in QUA |
16 |
| 6 |
Requirement Gathering |
12 |
| TOTAL |
70 |
References
Prior Tickets
NoneDocuments
EMEAWEBReturnsFileFormat_NEC.txtSpec Changes
| SNo |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
Field corrections are specified. |
Craig Spangler |
08/04/2015 |
|
| 2 |
Carrier needs to be the 3 character code. |
Craig Spangler |
08/06/2015 |
|
| 3 |
Need to work on Return Line No. and date format changes. |
Craig Spangler |
08/24/2015 |
Functional Requirement
Purpose/WHY:
Need to create the Returns Invoice File report for seeing Returns Invoices.In Scope:
Need to create the Returns Invoice File report.Out of Scope:
Returns Invoice File report regional versions are not required.Solution Summary
1. Need to use the following tables in the report: VBAK, VBRK, VBRP, LIPS and KONV.
2. Need to filter the data using following conditions: {VBRP.FKLMG}<>0 and {KONV.KINAK}=''.
3. Need to add the formulas for Freight, Sales Price and Tax in the report for example:
if {KONV.KNUMV} like {VBRK.KNUMV} and {KONV.KSCHL} = 'ZFRE' then {KONV.KBETR} else 0.00
4. Need to change the format for Date of Return to DDMMYYYY.
5. Need to check if all the specified changes are implemented in the report.
Test Plan
Test the report output data with ECC tables in NECNEQ.Solution Details
1. Need to use the following fields in the report:
Tag - ORDL (Hardcoded value)
Web Order No - VBRK - XBLNR
Return line no - This and just increase +1 for each line
EAN - VBRP - EAN11
Currency - VBRK - WAERK
Sale price - VBRK - KNUMV -> KONV - KSCHL(J3AP) - KBETR
Tax - VBRK - KNUMV -> KONV - KSCHL(ZWAS) - KBETR
Date of return - VBAK - ERDAT
2. Carrier needs to be the 3 character code, use below logic:
If {lips.KVGR2} in ["196","204"] then
"UPSS"
Else If {lips.KVGR2} = "042" then
"DHL"
Else If {lips.KVGR2} = "457" then
"DPD"
Else If {lips.KVGR2} = "511" then
"6DHL"
Else if {lips.KVGR2} = "379" then
"BESTWAY WEB"
3. Need to filter the data using following conditions: {VBRP.FKLMG}<>0 and {KONV.KINAK}=''.
4. Need to add the formulas for Freight, Sales Price and Tax in the report like for example:
if {KONV.KNUMV} like {VBRK.KNUMV} and {KONV.KSCHL} = 'ZFRE' then {KONV.KBETR} else 0.00
5. Here is the table links overview:
6. Need to change Date of Return format to 'DDMMYYYY'.
7. Need to send the report to NEC once all the changes are implemented.
Issues
Filtering the data is not specified, data fetched from 2008 onwards.